The BigQuery connector lets you read data from a BigQuery table and store it in an Algolia index.

​
Authentication

To authenticate the connector, you need a Google service account with the following permissions:
txt
bigquery.datasets.get
bigquery.datasets.getIamPolicy
bigquery.jobs.create
bigquery.models.export
bigquery.models.getData
bigquery.models.getMetadata
bigquery.models.list
bigquery.routines.get
bigquery.routines.list
bigquery.tables.createSnapshot
bigquery.tables.export
bigquery.tables.get
bigquery.tables.getData
bigquery.tables.getIamPolicy
bigquery.tables.list
resourcemanager.projects.get

​
Custom SQL statement

The connector imports your selected table by default. To use a custom SQL statement, replace your table name with %s:
sql
SELECT * FROM %s WHERE Status="Available"
Each row must have a unique identifier that Algolia uses as the object ID.
To stay within your BigQuery quota, don’t schedule tasks to run at most once per day.